The beautiful UK village that's right next to Britain's 'worst place to live'