with us, the groundwater level is currently above average. But the rain often comes as heavy rain, so you need a large cistern to be able to use it. Our well has been certified for over 130 years. However, it is rather fed by surface water.
Regarding your irrigation: - for lawns, Hunter rotators. Preferably the pressure-compensated housings. Sprinklers need to reach each other - for drip irrigation, Rainbird XFS line How many valves (irrigation zones) you need depends on your pump and garden. Use potable water line (PE-HD) as supply.
I am not a big fan of moisture sensors. Either battery-powered and then you have to keep changing them all the time. They stick out of the area. You need many to get a real "picture." The lawn shows you exactly when it is time to water. A fox stole a sensor from my uncle just two weeks ago. Wired ones require a lot of installation effort and also need to be at the exact right depth.
How complex the control system is also depends on your number of valves. There are no good controls for HomeAssistant. Basically, only power supply, Shellys, EPS... work here. I would rather recommend an autonomous system like Hunter Hydrawise. Here you can also access weather data from the surroundings. We use these at several locations. Irrigation duration takes temperature, sunshine hours, wind, etc., into account... Until you have programmed that yourself, you’ll go crazy. I myself use KNX. But mainly because I can control several zones simultaneously. Exactly that is not desired in "normal" irrigation systems because the flow is limited there. However, our controller is not nearly as "intelligent" as the Hydrawise system.
Have you already planned the irrigation? What data does your cistern pump have?