Carlisle has been named as the most welcoming city in the UK for tourists, according to a recent study.