In most circumstances, when requesting a drink, you would use the first. People will generally assume you want to drink the water, rather than, for instance, pouring it on a plant. However, if there is some reason they might think you want the water for some other purpose, you could specify that you want to drink it.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.