Hi Eldarth,
I don't have a direct answer to your question as this isn't something I've tried or an area I'm terribly familiar with but I can at least try and give you some leads.
One of the easier ways I have tried to find what animations are available is by looking at the shared _Global_CharacterAnimations goal in the story editor as there is a defined list of DB variables at the top. However, these are only for character animations and don't cover all the object item possibilities, so that doesn't cover your case here.
Next, you can use Norbyte's tool to unpack the Shared.pak file in the game data folder. That should create a folder path of something like "..\Shared\Public\Shared\ActionTemplates". You can then use Norbyte's tool again to convert the LSB files to XML and see the different animation templates for different kinds of objects and creatures. What I haven't looked at yet is how to determine which animation template the fountain you have is using.
All that being said, it may be possible that the water is not an animation at all, but I don't know that. There may be a much easier way than what I've posted here but figured I would share whatever I know about, hopefully it's not down the wrong path!
