I really suck at VFX so I took some time to get better at it and came up with this little scene in the process.
I very loosely followed the process that Koola did. You can find a brief tutorial on how to do it here: https://forums.unrealengine.com/community/work-in-progress/29251-koola-s-stuff/page24
Second Attempt: Water Ripples in UE4
First Attempt: Water Ripples in UE4