If it's a one of thing or in the distance, you may simply search on sites like Turbosquid for pre simulates water sprays, splashes and crowns. Its a cheap way.
Other wise, market leader for most features (and obviously largest price) is realflow. They recently also introduced a tool spcefically for crown splashes, which can help with a certain fountain flpash look.
Also there is Phoenix FD by Chaosgroup, which is the best solution, that works directly in 3dsmax.
