Rain is the biggest water threat that houses face, but there are some slow and steady mechanisms that can snowball on you, too