Animating a fluid water fountain
You need to set the inflow's velocity to be positive in the Z direction. This will force the inflow's fluid up, giving you the fountain effect. Here is a bit about an example I quickly put together.



(click on the images to see a larger version)

Inflow settings (just a simple cube):



Domain settings:



Outflow plane below the fountain to "kill" all water than falls below. This is like a vacuum to "suck up" the water.



The fountain model itself is just a simple fluid obstacle.