Machine learning and time series integration for agricultural water footprints and scarcity index estimation in Northern Nigeria