Hi Krishkal,
Thank you for the logs. I see that this device behaves similarly to some other Sonoff devices (it requests a reply from the hub that is not sent by HE platform), but probably this is not the problem.
As chrisbvt mentioned, all Zigbee water, contact, and motion sensors operate in the same way—they only send a state change notification once. If the message does not reach the Zigbee coordinator (the hub) within a time frame of 6 to 10 seconds, the state change Zigbee message will be lost.
I have a workaround implemented in a custom driver for Zigbee contact sensors - the current state of the contact is refreshed automatically aftrer every battery report. There is a time window of 1-2 seconds after a bettery report when the sleepy device will respond to a refresh (attribute read) commands. The same approach should work in the custom water leak driver, but it is not implemented at this time.