SMS dit: Drought management and its impact on public water systems