From trapeze workshops to onsite aviaries, these children’s holiday programmes have it all