Hidden fountain sump

If you wish to have a hidden fountain sump, below shows how it can be done.

The Overflow pipe (Item C) Is at the top because it acts as an overflow, it will take the pumped water from the top pool back to the bottom pool. It should also be a wider diameter than the riser pipe (D)