The village has been named as the UK's best 'secret' place to live - and it's just a stone's throw away from some major cities.