You can buy preformed falls that are made for pools and ponds...plus
they don't weigh that much and come in small to very large sizes...
they have flat bottoms made to sit over your pools edge "with a lip"


...run a search for Talavera waterfalls.

Good luck!