Billions of pounds must be raised to ensure Britain's water security and avoid queueing with canisters for emergency handouts in future, the National Infrastructure chief has said.