The CORE Fundamentals of Physics Chapter 5 and 6 deal with particles and dynamic paint respectively, there you’ll learn all about every detail of it.
If you go about 39 minutes in you can see how I did my fountain with that system here: https://youtu.be/lO3TaLCzPRQ Like I say you’ll have to adjust the settings until you find a look you like but the principle applies.
