Chester has been ranked the UK’s most welcoming city despite also being considered one of its most haunted.