The Cairns region is at risk of a drinking water shortage within just two years if another multimillion-dollar pledge isn’t made in the next federal budget, which lands on Tuesday.