Okay everyone here is the link to the video.
Thank you all for your comments, it is truly appreciated!
As far as design...my step-dad helped bring my vision to reality. The actual "waterfall" is made from acrylic, there is a hose coming out of the bowl into the pump and up through a hose to the top of the waterfall. (The hoses are not inside the cake) I did not want the hoses running throught the cake. On the back I cut out a notch where the hose runs up the back. On the cake dummy, I just put the top tier on top of the hose (also in a notch), but on the actual cake I will use a cake plate to cover the hose and the top tier will be elevated. I put some cheap plastic I found in the craft department at Wal-Mart on the botton of the acrylic to help force the water down into the bowl and not the cake. As far as water getting on the cake, we made the sides of the acrylic pretty high to help eliminate this problem. There is a minor splashing problem in front of the bowl when the water from the waterfall hits the water in the bowl, but it is very minimal. As far as the stand, in this picture I just have the cake dummy sitting on two styrofoam dummies under a sheet for picture purposes to elevate it above the bowl. For the real cake my step-dad has a made a box for the cake to sit on and which will also house the pump and hoses. I think that is about it, sorry to keep rambling. Let me know if you have any other questions. Thanks!