We consider the barotropic Navier--Stokes system driven by a physically well-motivated transport noise in both continuity as well as momentum equation. We focus on three different situations: (i) the noise is smooth in time and the equations are understood as in the sense of the classical weak deterministic theory, (ii) the noise is rough in time and we interpret the equations in the framework of rough paths with unbounded rough drivers and (iii) we have a Brownian noise of Stratonovich type and study the existence of martingale solutions. The first situation serves as an approximation for (ii) and (iii), while (ii) and (iii) are motivated by recent results on the incompressible Navier--Stokes system concerning the physical modeling as well as regularization by noise.