New lease of life for historic city centre pub under new management