I use solenoid water valves controlled with 7 Day Heavy Duty Digital Programmable Timers
and drip irrigation tubing and emitters. You could also use gardening drip irrigation timers, tubing and drip emitters.
True that... anyone that says water is100% flood proof is bullshitting you.
I have my res sitting on a stand. The stand is sitting inside a large plastic cement mixing tub. Large enough to hold the water in the res. The grow space has a liner that is somewhat leak proof well supposed to be.
They also make flood tables that fit inside tents of all sizes. Thats my next move. That way after harvest I can just take the drain tables out and spray them off to clean instead of mopping .... in theory it wood seem like less work?? I dunno.