AI for Open Science: A Multi-Agent Perspective for Ethically Translating Data to Knowledge