Geek Q: What exactly is water retention?

I get that water retention is when the body's cells hold more water, but which cells, specifically, do that and why? I know high sugar load and hormone changes both cause water retention, but do they operate through the same mechanism, and is the water stored in the same place(s)?