Sodium water retention

Sodium causes water retention but where is the water held? In muscle like creatine or fat cells?

It’s in the extracellular space–which means outside the cell, not inside like creatine. That’s why water extracellular (in what is called the intersticial space) obscures muscle definition much like fat.