The mechanism for water toxicity is physically displacing ions in the brain, causing osmotic damage. (This also explains why lower amounts of water are safe.) A thumbprint dose of LSD is nowhere near high enough to do something like that.