You can just do a google search for "bean animal overflow' or " herbie overflow". There is a TON of info out there.
The Herbie style basically uses 2 drains. One is set up as a full syphon and has a gate valve installed inline. The second drain is an emergency/open drain.
The bean animal is basically the same, but has a third drain, the secondary drain. This drain is used as a backup in case the full siphon gets clogged. In which case it becomes a full siphon.
DC pumps are more efficient than AC, usually quieter, and use less power. They are also controllable. It is not that DC pumps need battery backup while AC do not, but due to the power draw of an AC it is simply not done without a generator. DC is much easier to power for long periods on a battery where AC would only last minutes on even a rather large battery.