A pretty UK town, less than two hours from Manchester, has been crowned the UK's 'most welcoming' destination for 2026, and its charm is undeniable alongside its cosy tearooms