CMP can be used for tanks. The Handbook of Steel Drainage & Highway Construction Products has a lot of photos and detailed info to design connections, etc, and a company like Contech will help to design. The City/County/DOT where you are may have standard drawings for detention systems - in these parts there are many restrictions and criteria on allowable configurations and dimensions that must be met to be permitted.