From pubs and hotels with ‘A La Bark’ menus to museums, castles and even a wildlife park and boat trips, these are the places that bend over backwards to make mutts welcome.