No drinking/dancing, a rowdy bunch and lots of kids - how can i keep everyone happy?

My family is devoutly Christian (no alcohol, no dancing, etc.). They are used to fairly boring weddings and refuse to attend any events with “debauchery”. My future husbands family drinks to the point of needing help getting to their room. My future husband has a habit of falling asleep at wedding venues. His mother is no different (more likely I think she could be an alcoholic in denial!). I have no issue with either groups other than making sure both have a great time when their idea of a great time is so different. I’m doing immediate family only and our best friends, but I’m not sure how to ensure a great time for everyone involved. There will be around 40 kids at the wedding too (mostly kids honestly). Is there a venue that I can select that would ensure that after dinner 1) kids enjoy themselves 2) some nature? for the quieter folks to enjoy 3) a way for the party folks to group together as well...
I considered a farm with petting farm animals, a resort that’s kid friendly too, a water/fire feature, etc. My future husband suggested a resort or doing it at home. We’ve just begun our wedding planning so we haven’t hired a planner yet! I don’t know how to make it fun for 3 groups of people and it’s stressing me out. I suspect I’ll have to have basically 3 different activities simultaneously with enough distance in btw that everyone has a great time without stepping on anyone else’s toes. Has anyone done something like this successfully?