The historic market town has been praised for nailing 'the sweet spot between city buzz and countryside calm'