Chris Adams, local government chief behind Karratha’s transformation, resigns after 10 years in the role