Check out Saeid on Utube.
He's posted a video showing how to move water with an air pump.
I haven't tried it yet, but I'm going to!
Originally Posted by fish_4_all
It can be done but I don't know if you will be able to do it with the standard air pump we use for the hobby. An aircompressor or an indistrial pnuematic air pump should have enough pressure to push water up to a water fall. It is actually rather inexpensive to get a small water fountain pump to do the job without air. My dad carries them for his ceramic shop and I think they are like $30. Smal fountain pumps only run $35-60 and would push more than enough water.
Is there any specific reason you are wanting to use air for the pump?