a rather pointless hypothesis on how water dowsing might work:

water is an electric dipole, and is diamagnetic. meaning that as it moves through a magnetic field, it will hypothetically arrange in an opposite polarity, creating a small opposite attraction.