Council executive resigns after scandalous Ombudsman report