The head of Invercylde Council has stepped down from the position after he was charged with two domestically-aggravated offences against a woman.