Re: Will this work?
Do some research on how to build ponds and water features. It is not rocket science and you do not have to re-engineer the wheel to do it.
The first thing you'll find is a product called pond liner. The second thing you'll find is that you can do any type of free-forming you want with this product that is specifically designed and made for what you're wanting to do, unlike bed liner.
The next thing you'll need to know is what it's going to take in the way of pump and plumbing to handle the water requirements of your plan. (hint: water is heavy and "gains weight" with each foot rise in elevation you're trying to push it.)
You should also research what it takes to keep the water clear while supporting plant and fish life. The best advice that you can be given right now is to thoroughly think through exactly what it is that you are trying to do and to correctly design and build the system to support that plan. DO NOT cheap out and think you'll get by, you won't, and the money that you do put into this project will be wasted.
I suffer from CDO ... Its like OCD, but in alphabetical order, LIKE IT SHOULD BE!!!