A new holiday index has named the best places for a family staycation in the UK, with a surprising destination topping the list