The Cornish village of Crantock has been named the UK’s most popular pet-friendly destination by a UK staycation specialist.