Water issues are one of the most common—and costly—problems in a home. Here’s what inspectors look for and what buyers should never overlook.