Brazilian authorities are pledging millions of pounds to bring water supplies to the country's drought-hit north-east region.