The City of Mandurah is set to hold an extraordinary election in September after the resignation of one of its councillors.