SND,

It depends. If you're modeling a pump that is anchored to a slab at grade, then a zero-weight rigid is fine. If you're modeling a vertical vessel, then you want to use a pipe element. I'd use the real weight density, in case this affects system displacments due to boundary condition arrangement.