A historic Peak District hotel just outside Sheffield has been named the best place to stay in the UK.