Can material effect geometry, to which its applied to?

Short answer pls, (yes, no)?
Possibly some tooltips where to dig?

PS: My point is to make water material with geometry waves.

Yes, you can do that with tessellation and world position offset, and lots of math.