This picturesque Cumbria seaside village, named one of the best coastal places to live in the country, is close to Lake District hotspots but remains overlooked