The leader of Inverclyde Council is stepping down from his role after appearing in court charged with assault and threatening or abusive behaviour.