This is a diagram of the most efficient and discreet built-in waterfall system that you can make.
This is one of my built-in waterfall systems.