The leader of Perth and Kinross Council has stepped down after being charged with embezzlement.