A councillor will face a series of sanctions after an extraordinary outburst which led to a ten-month inquiry.