The 'business end' of my aquarium isn't very attractive looking, but it's space saving and it works great.
The main design that should be incorporated into
every aquarium with drains leading to a sump is to have water flow in the direction of the overflow(s) so wastes get flushed down the drain(s). This is why I have my two water returns at the opposite side of the aquarium from the drains and I'm directing the flow towards the drains.
Those two drain intakes are 90 degree elbows. I used a bushing to increase their top (intake) diameter.
Keep drilled bulkheads at least 2" away from any edge of an aquarium and 2" from another drill spot. (For example: the bulkheads on these two drains pictured are centered 6.5" from the top edge of the aquarium.)
The drains lead directly through the back of the aquarium and down the drain lines into the basement.
My MJ's turn on and off and are directed against the flow of the main returns. This alternating laminar and then chaotic random flow helps to lift and suspend detritus (among other important things.)
This is an excellent and (relatively) inexpensive method of recreating water movement for SPS. It's not the only way to do it, but I'm very happy with what I have set up. The penductors I'm presently considering aren't necessary, but will only enhance what I've already got going on.
If you have any questions, just ask.
I'd be happy to have you over some day to check it out.