With many Brits opting for a staycation, this stunning region has come out on top.