When drinking directly from a well or a pond it is showing the message that he drunk some water, but it does not have any effect.
You can "drink" a hundred times, your status does not change.

Filling a bottle at the well/pond and drinking from the bottle is working fine.