You will see fountains like the one in the photo at shopping centers and casinos. This one is near a shopping mall near my house. If you look closely, you can see that the fountain floats. At no time can a huge fountain like this one be on the bottom of any pond or it will try to suck up debris and burn out quickly.
If you have a huge pond at home and want to use something like this, watch that the wind does not blow the water out and cause the level to drop to dangerous levels. Sometimes you have to give in and install a float valve to keep the pond full of water.