How do you ground a 200 amp service with no water main?

You need two forms of grounding according to the code. Grounding to the water main is typically the best ground in a building. If you don't have a water meter you can add an extra ground rod.