The picturesque Yorkshire village featured in a British TV show offers cobbled streets, historic museums, scenic walks and charming independent shops