Prosecutors have decided not to proceed with the case against a former council leader who was facing assault and threatening or abusive behaviour charges.