That's not sand pouring out of there but water. You can make a waterfall with a submersible pump running the water line up the back of piles of rock or you can stack the rock or slate around your current filter to give the appearance of a water fall.
If using a pump, you want it powerful...