I love a good fountain and waterfall in a backyard landscape design. The reason is that it adds a nice element of nature and the forest to what is otherwise an urban environment. This design is great because it looks like the designer actually gathered up rocks form a river and built this waterfall from scratch. Sure, you can buy a fountain at a home and garden store, but if you can do something like this then you are doing something much more personal, gratifying, and frankly, more aesthetically pleasing. The pond looks like it could very well have some large goldfish swimming in it too.