I didn't stop moving for very long, that might have been the issue, also this was very shallow water.
I did find a lake in my single player game and had no issue drinking. I was holding still, and using a toolbelt slot with no items equipped, not sure if that last part mattered or not, but hey it worked at least.