Snow: If i were to use this in a snowy terrain, the water would be noticeable, depending on the height of the snow/its accumulation. Due to the amount of now, once its hit by water, the density of it will increase thus making it heavier. Though, the way my opponent would notice is the color of the snow will go from white to a darkish color.
Grass: With he grass, it will be a little different. I still find it kinda cool. Im guessing depending on the area the tech is used, if the opponent comes running too fast, they will slip? And the moisture from the grass will be a cool thing.
Desert: Similar to the snow, the water will make the sand heavier, thus making it also noticeable. Though, this can be like an oasis. I never asked, what rank techs can this water source created support? But, if its large enough, i can use a few of my fav water cj with this, having an edge.
Plain: This would be good. I think with the water, the dust in the area will create some silt, and a little mud, allowing the terrain to be a little sticky.