Liability:
Your policy generally covers you if you are liable for property damage caused by an occurrence relating to water, subject to the policy's conditions, limitations and exclusions. There are, however, some exclusions in the policy which may supersede this, for example if the water related property damage arose out of your business pursuits.
A full list of exclusions can be seen in the sample policy here.
Contents:
Your contents are covered from the one-off accidental discharge or overflow of water or steam from a plumbing, heating, air conditioning or automatic fire protective sprinkler system; household appliance; or waterbed. As an example, if your air conditioning unit expelled water in a one-off incident and damaged your personal property, your policy would generally provide coverage for this, subject to the policy's conditions, limitations and exclusions.
Other damage caused by certain specific water-related events is excluded. For example, damage from flooding.
A full list of exclusions can be seen in the sample policy here.
Coverage is subject to all the terms, exclusions and conditions of the insurance policy. Please see the sample policy for further information.