If you’re using Zigbee and have a decent mesh going in the area where you’d like to install it, support for a water meter/valve device meeting all your requirements has just been added in Z2M’s latest release. It’s available from Zemismart, who mention it’s also compatible with ZHA in the second pic.
I had to pass on it because installation requirements are too restrictive for my situation. Also, the fact that it’s battery powered had me worried a bit, but it seems the water flow recharges the battery (at least this Amazon listing says it’s hydraulic powered).