SCALE: Towards Collaborative Content Analysis in Social Science with Large Language Model Agents and Human Intervention