What type of common materials can I use to detect water infiltration/leaks?
What you're looking for is called "water contact indicator tape".  It's used in cellphones and other electronics to detect when damage was caused by water for warranty-rejection purposes.  You get it wet, and it turns bright red, as shown on page 2, and stays that way permanently.

Though it's generally only sold by the 100-count reel.