This mod adds water animations to fountains that came with IP and several store purchased fountains and hot tubs. This mod will override and fix/tweak items that are currently installed on your system. If you do not have the item, the mod will not do anything.
The download includes all items. Extract the files that you need to your Mods/Packages Directory. Clear your cache files before restarting your game. If you open a game where you had already purchased a fountain and no water animation is present, delete the item and repurchase again. The animation should then play.
You can find the mod here: SimLogical