Here's why:
* "Water" is an uncountable noun. This means it doesn't have a plural form like "waters."
* We use "glass(es) of water" or "bottle(s) of water" to quantify water.
Here are some corrected versions of the sentence:
* I drank two glasses of water.
* I drank two bottles of water.
* I drank two cups of water.