I wish I had some good news for you. I never got any further with this than the wishful thinking phase. If it’s possible, we’re going to need someone much smarter than me to figure it out 
Additionally, all the third party smart water meter/shutoffs I looked at were prohibitively expensive - eg Flo by Moen is $700 here in Canada.