A new ranking has revealed the best and worst places in UK for a staycation.