Oh, I believe you misunderstood me.
I was speaking of the "Water Barrel" block, not the "Fresh Water" item.
The water barrel provides you with infinite water, except that the way it works is: you have to get an empty bucket in your hand, right-click the water barrel, which moves the bucket...