Check out this AWESOME backyard stream that my client had built in the backyard of her Charlotte home in Lake Providence Estates! I sold her this house, and it was perfect in every way, except that there was more road noise than she cared for. I suggested that she put in a water feature so that she could enjoy the sound of a water falling instead of cars.
This is the breathtaking outcome! The water re-circulates, causing a continuous waterfall. She's got koi in the pond part, and she even installed lighting so that the feature can be enjoyed in the evenings on her deck. Creative, huh?