My suggestion is a in-ground pond.
At base it can be preformed or flexible liner.using liner and deep of pond will depend of rocks location.
If your house located on top of a rock, i imagine how much natural stones and rocks you have avaible around,
it can be easy used for decoration of spillway or building fence between pond and sidewalk.

Any a waterfall have to be lined to prevent water loss. Choose from preformed plastic and fiberglass units or flexible liners, which vary of sizes, forms, and structures.

Preformed units come in several forms, including pools, tiers, single cascades, and joining section for a waterway, allowing various setups.
Flexible liners under spillway allow you unlimited designing