I would use SimpliSafe and Kangaroo water / humidity sensors as a guide. They work, and they are really useful. I have six, but would switch to Wyze for consistency. Kangaroo has a good GUI for their sensors.
For 2025, a mini camera with 360 degree view pops up out of the sensor and looks for the water leak, and videos it. Wyze produces a water shut off valve with leak sensor and Away and Home modes. When you leave town, the Wyze house takes care of business.