I used.. 9 emitters (directional) for the areas where the water came out. I also set the 8 emitters (all of them excluding the top one) to collide with the base, then I set it somehow to kill the particles when they collide with the base of the fountain.

Thank you everyone for your help! I will check out that link tomorrow.

Glad to be here at SM with you all. Thanks again!