Pretty constrained area to work with, especially for a waterfall. Possible, but could be tricky. I would recommend possibly a bubbler of come sort. Let's see what some of the other guys have to offer.
Is that a stamped concrete patio?
What space is available under the stairs?
"Everybody is ignorant, only on different subjects." - Will Rogers