If dwarves drink water instead of booze, they get an unhappy thought IIRC (or maybe its just for dirty water). They also will start working slower. The long they go without booze the slower they work.

However if they don't have access to water, then they will get unhappy thoughts about being thristy and will either go insane from the unhappiness or will die of dehydration.