From resorts with kids’ clubs to boutique storybook-style stays, you’ll find places to bring the tribe both on and off the beaten path