Revealed: the best spot in the UK for a staycation