Nothing too spectacular but this is the view from one corner of the dining room. (Don’t mind the trampled and cut - making Reno room).
In my mind, there’s just so many possibilities to make that area more interesting than just the tiny tide pool entrance the prev owners had as a starter.
Opening the window, drinking coffee, nice morning, relaxing with a working beautiful planty pond=
(As added historical the 1st owners also had a hot tub on this concrete slab along side the pond. Sounds wonderful)
View attachment 143003
This pic and some further clarification really helps! I understand now, better, what you're trying to do. So, I'd definitely build up the back with a berm and I'd add some 4-6' shrubs/trees behind it; that'll dissipate what that fence is doing to your pond area, imo. Nothing wrong with having a tube of water erupt out of a jumble of rock and flow down to the pond. But most want the waterfall (definitely something I wanted for sure), its look and sound especially. A lot here has to do with your landscaping AFTER you build your falls, imo. You can take away the 'hill' look by adding large background rocks (give them 1/3-1/2 buried look) and plants that complement your other landscaping.
I know you want specifics re numbers but I think here, in this case, I REALLY think this would be good for you to just sort of wing it. Not totally but you'll learn a LOT about what type/look waterfall you really want. Pics of others helps and I'd find one you like and try to model it, but it builds character as YOU build your waterfall. There, now didn't I sound just like a dad??? But it's true, you'll build 'pond character' and what you end up with probably won't be the final version but it'll then spur you to tweak in the future to get exactly what you like. And realize, tweaking might indeed mean rebuilding, so, don't go making anything THAT permanent that it's a pita to unbuild. My waterfalls are just rocks laid overtop solid concrete slabs (4x8x16) laid on an extra piece of liner. What you do with the facia rocks then won't make or break your waterfall as the sub-structure will still be there. For a weir, I took a plastic file bin and cut a 'edge' out that I heat-gunned down into perpendicular position. The water enters the back near the bottom using bulkhead fittings. The top (of the file bin) I put back on and stacked my flat rocks on that. To help soften and hide this area, that's where the plants (hostas, creeping jenny) emerge from the back of the bowl and protrude out and over the top of my falls. This is easy to do and again, naturalizes.
Good Luck! Post pics as you go but don't get either too high or low until you finish and actually have it working for a month, just to see how it looks to you.
(looking at your pic again, even if you did nothing, I'd still opt for 4-6' trees/plants/shrubs to help out your coffee-moment view! Get something that flowers, stays manageable, and is not too aggressive re roots and such!) Taller plants like day lilies, iris, butterfly bush work great, too.