Must the president of a local SCRA chapter be a COL? Other positions?

No, anyone (any rank or civilian) who is actively engaged in the chapter and willing to perform the expected duties may be a chapter president. This is true for all chapter positions.