North Yorkshire and Durham have been named in the top 10 regions with the most haunted hotels in the country according to a new study.