This UK city can often be misjudged, but it's a treasure trove of unexpected delights with its ancient architecture and flourishing independent scene