The water onboard the ships is processed the same as most bottled waters - reverse osmosis and filtered. It's the same water that you can get at the drink stations, and is used for preparing food onboard. It's also the same water that you get at the tap in your room.
As noted, some people do bring their own bottled water, while others don't.