How Much Carbon Used in Making Drinking Water?

I am building a spread sheet to analysis the carbon footprint for the power and energy usage of the hotel, an I finally got the carbon footprint for water from the kind people at Yorkshire water, every megalitre of water
(1000m3) produces 71kg of carbon and 261kg of Co2.

Hope this helps. If you need anybody out there is attempting to calculate the same.