Find out which "picturesque" coastal village in Northumberland, North East has been included among Britain's greatest, according to travel experts.