Multi-family reunion trip - where to go?

We are looking for a location to host a reunion next summer. There are single individuals, couples, and families with kids ranging from infants to teens.

Looking for a location in North America or the Caribbean near a major airport as our group is spread across the US.

Something where we have a central hang out spot but each person/couple/family has their own sleeping space and bathroom. A place that has outdoor activity options. Ideally like a small resort we could take over yet each get our own rooms.

Open to anything including mountains, beach, lake or a ranch. We want something nice but not something stupid luxury or expensive.

We considered getting multiple houses in Hilton Head or Kiawah, but that feels too far from a major airport. Various hotels looked awesome but lack a central hangout spot.

Please help!