Water Management Automation for an Apartment

Looking for a fully automated system to manage borewell and metro water usage, including sump-to-overhead tank water transfers, without manual intervention.

Has anyone successfully implemented this? Any reliable service providers or tech recommendations?

Thanks!