Yorkshire named as UK’s best holiday destination