A new study has revealed the best and worst UK staycation destinations for families, with one popular city being named as the worst place to go on a family holiday