It's home to a rich history, charming atmosphere and a surprising number of highly-rated restaurants, cafés and pubs