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