Overpowering: yes. If the speaker is 8 meters away from you and the waterfall 2 meters, the waterfall will be perceived as 4 times louder at the same frequency and volume.
From the terrace, a boundary wall 400 cm deep, 200 cm high. It already absorbs some sound.
Now perpendicular to the wall, another wall 1.60 cm high (You can create a wind-protected seating area behind it) and from there 80 cm down with a waterfall:
From the remaining 80 cm height, it now goes down over several roaring rapids
After about another four meters, everything lands in a pond with a water fountain
and from there everything is pumped back up again.
Such a thing can be planned for you by a landscape gardener, depending on your skill you can also do it as a DIY project:
You can build the wall for the waterfall yourself from formwork blocks and facing bricks. A watercourse is available prefabricated in GRP, for the slope you still need some earth fill. And the pond basin itself is designed with pond liner. Add a powerful pump and a water spout. Done.
As a starter, there are also prefabricated basins like this—if your preferred lounge spot is directly next to it this could already be sufficient (but only for that!)
