Sounds pretty cool, thanks for the details! Any chance of some pictures? My worry would be the same, I don’t know if I trust myself not to flood the house lol

I did think about using a mechanical float like in the back of a toilet, and an overflow drain in case it never stops filling