A holiday cottage in a North Yorkshire village has been named one of the most dog-friendly places to stay in the UK.