For water transportation, you will need to buy a special water tank. You can find them in an in-game store. Keep in mind that there are different kinds of water tanks in FS22, so be sure to think about what kind of tank you need. They vary in characteristics, capacities, and prices. You can get a water tank for $9500 and also for $68000.