Onslow has finally reopened after cyclone Narelle left the Pilbara mining town without fully functioning mains water for more than a week.