In order to use the Fluid Surface Plugin you’ll need the source build of the engine from GitHub. You’ll need two things before that. You’ll need to link your UnrealEngine.com account with GitHub and the free copy of Visual Studio Express 2013 to compile the source code.
[Here is a vid to walk you through setting up the GitHub account and building the source with VS 2013.][1]
To answer your question about spawning the particle this should be easy to set up. I added onto the projectile from the first person template as a simple demonstration.
In the image below you’ll just need to generate a hit even drag out from the hit location pin and type in Spawn Emitter. The rest is how the projectile is setup.
I hope this helps! If you have any questions feel free to ask!