I think for what you want to do you need something that will trigger when power is applied. This is just a dry contact relay board, but not a dry contact sensor.
A water leak sensor is usually used for this purpose, as is discussed in other posts on here.
