If you were able to shift most of your guest influx to the 'wet season' that would help.
You can grow most of your oil, olives and nuts, without worrying about water during the dry season.
Alot of fruits ripen in the dry season and taste better without the extra moisture so again less worries. They can also be fermented/water kefir/alcohol/vinegar, dehydrated/soaked in alcohol.
Honey can also be made in the wet season and used in the dry season, you can even cheat and feed the bees fruit juice, as a way to preserve the fruits and the pulp can be dehydrated.
Growing your own grain sounds like a bit much, but that too can be grown in the wet season.
Aquaponic systems are said to use 90% less water, so you could take that route, water tank=fish pond, same pump+irrigation pipes, a bit more electricity because the water will be recirculating every hour vs just at night. Grow pipes can be placed in raised beds, and hidden for a more natural look and ease of harvest.
https://docs.google.com/presentation/d/1DaQgq7raA2srDWJirBhkymfejWRtEhYHVuzFGAjJSGo/embed?start=false&loop=false&delayms=5000&slide=id.g68452b3ff_0_37
Iterations are fine, we don't have to be perfect
My 2nd Location:Florida HardinessZone:10 AHS:10 GDD:8500 Rainfall:2in/mth winter, 8in/mth summer, Soil:Sand pH8 Flat