A new study has revealed the best places in the UK for a family-friendly staycation, with one location coming out on top for a holiday with the kids