Water intoxication leads to hypo-osmolality (not enough blood solutes) and hyponatremia (not enough sodium). The most immediate problem is cerebral edema leading to seizures, coma, and/or death.
Psychogenic polydipsia is the term for compulsive water drinking, but it doesn’t necessarily lead to water intoxication. It is most often associated with mental retardation or mental illness.