I think it's a very cool idea, but I would really make it either a circular thing or else make it in the middle of a big pond. Definitely don't expect to make something work out where the water volume above ground level is greater than the level below ground level. Also realize to make a good stream is going to take a great deal of pump power.