In effect stale water is useless. The biological makeup of the hydrogen and oxygen atoms have begun to break down.

Water is water is water. It doesn't become old and not-water, no longer wet, hydrating, or useful, suddenly incapable of being absorbed and utilized by your body, slipping untouched through your system like a silver snake.

It's not as tasty when stale, that's all.