Question about the water plugins for a beginner

I have a few ideas in mind for games that i want to go ahead and prototype myself, that either involve water or some forms of a fluid. What Im struggling with is what features/plugins i should and should not use. So im stuck with this idea of wanting the large open bodies of water while using a open world system. but the problem is I dont want water, i want a more gelatinous sticky form that thats kind of metallic and grainy (think lava lamp meets edible neon angle dust),only about 6-8 ft deep throughout my whole map (falling off deeper on world border). should i be using the water plugins? are the water surfaces easily changeable? Thanks in advance! -Fluffy