A backoff approach to design of optimally flexible water networks under uncertainty