Generally speaking, water coming from the top down is covered by a standard homeowners policy. Water coming from the bottom up is not covered by standard homeowners insurance.
For example, burst fire sprinklers in the ceiling or seepage behind drywall from an ice dam in the gutter would be covered by homeowners insurance. Seepage through the foundation and overland flow, however, would not be covered. This would be covered under a separate flood insurance policy.