Howdy Bear,
If you are looking at a new Mog you are looking at the U300/400/500 which for a chassis and cab will be $80,000USD. I think you will be able to get it for a little less.
Look at the 406/416 trucks. They are rated at 6,000lbs carrying weight. Also you can look into newer models like the 1300 and they are a big truck and carry even more. If my math is right 300x8=2,400. I think there are about 2.2 lbs. to 1Kg which would make the weight of the water 1090Kg. You will be well within the capacity of any Mog you decide on. You can even carry your ice chest with no problem
