It varies. The water company likely doesn't know the difference, but the hookups for a RV and a mobile home are not at all the same.
Ask the management of the mobile home park. Water is probably the least of your problems, sewage and electrical hookups can be quite different RV vs mobile home, and the power company can be a stickler for following code. Banged heads with those when they were rewiring entrance service to a 70 year old house I owned, ended up putting in a new breaker box and bypassing all the old boxes. It is not like just plugging in a cord.