A fountain nozzle is essentially an attachment which usually fits onto the top of a fountain pump to create an attractive water display. Much like the sprinkler head on the end of your garden hose, the fountain nozzle will convert a single jet of water into something far more impressive and interesting.