Sounds like you already made the decision .
There are many over flow boxes that use either “ U” tubes or pumps to get the water over the tank and into the sump .
you might find later that they’re a bit of a pain in the butt or .... they work exactly what you’re looking for .
Good luck !
