The Kimberley's Dampier Peninsula is set to benefit from a $37 million state government funding injection to shore up drinking water supplies for remote communities.