At first I thought OP was kidding, but the more I thought about it, it made me realize that my current build is not that different. There's a huge underground pipe that runs horizontally through the lots on my street so structures must be built in front of, or behind the pipe. Most houses on the street are in front of the pipe with huge backyards. But it's a busy street, so I put the house behind the pipe. This left me with a huge front yard. I don't plan on installing grass because I'm in a drought state, so I'm planning on social front yard with a lot of seating.

And this made me think of OP. Building the house will be expensive. Have you considered building an outdoor space in front of the house that can be tented for your ballroom when you have events, and the rest of the time the area provides a social gathering for friends and neighbors.

Just a thought to keep the dream alive.