The historic pub was named as the best in the city