Your best bet is to utilize multiple layers of redundancy. I use the Neptune ATK which has 4 layers of safeguards to prevent overflows:
1. Low water level sensor, used to detect when to turn on and turn off the ATO.
2. High water level sensor. If the low sensor fails to turn it off, the high sensor turns it off and an alarm notification is sent.
3. A timer that doesn't let it run for more than X minutes. If both the low and high sensors fail to turn it off, and it runs longer than normal (a value you specify which is normally long enough to account for typical evaporation in your system and environment) then the ATO is turned off permanently until you manually intervene to turn it back on. You will receive another alarm notification of this abnormal situation.
4. A mechanical float valve to pinch the supply line closed. This is the last line of defense.
I have never had any ATO overflows with the ATK in the 3+ years I've been using it. See my tutorial on the Neptune ATK for more details:
Part 3 of our series on learning how to program your Neptune Apex for automatic top-off in a saltwater aquarium.
www.reef2reef.com
You can also build this same type of multiple redundancies with other automation controllers and some DIY skills.