Where do you get a water stone in Pokemon snakewood?

You are likely thinking of "Pokemon Snagwood" as "Pokemon Snakewood" is not a recognized Pokemon game.

However, there is no Water Stone obtainable in Pokemon Snagwood. This game does not feature any of the traditional evolutionary stones.

If you're looking for a Water Stone in a Pokemon game, you'll need to specify which game you're playing.