The Cotswolds has been ranked best in the UK alongside the Lake District and Cornwall.