I use this DIY overflow when rains overflow my sump.
The way it is designed, once primed, it is amazingly efficient, and stops and starts whenever water hits the right level.
Although the PVC on this is small bore, I have made larger versions, for heavier flow rates.