That's cool! I always wanted to have a nice water feature in the backyard to go with a fire pit. I almost built one back in Cincinnati after I got the deck and fire pit done, but I changed jobs and moved to Memphis just a year after my daughter was born. I wasn't in Memphis long enough to build one at that house either.
Now that we are in this house (and not moving again) I plan to do one here. The back yard has the perfect slope to build a nice double cascade waterfall into a small pond like yours.