Towards Locally Relevant Global Soil Moisture Monitoring Leveraging Remote Sensing and Modeling for Water Resources Applications