If it is just rain water then I agree galvanized steel pipe could be used. The question is with regards to how the water gets into the pipe and what is it supporting that you put a big hole in the wall of the pipe.
The structural engineer would need to be involved
Galvanized pipe would be required by code
1102.2 Inside storm drainage conductors.
Inside storm drainage conductors installed above ground shall conform to one of the standards listed in Table 702.1.
TABLE 702.1
ABOVE-GROUND DRAINAGE AND VENT PIPE
MATERIAL STANDARD
Acrylonitrile butadiene styrene ASTM D 2661; ASTM F 628; ASTM F 1488; CSA B181.1
(ABS) plastic pipe in IPS diameters, including Schedule 40, DR 22 (PS 200) and DR 24 (PS 140); with a solid, cellular core or composite wall
Brass pipe ASTM B 43
Cast-iron pipe ASTM A 74; ASTM A 888; CISPI 301
Copper or copper-alloy pipe ASTM B 42; ASTM B 302
Copper or copper-alloy tubing ASTM B 75; ASTM B 88; ASTM B 251; ASTM B 306
(Type K, L, M or DWV)
Galvanized steel pipe ASTM A 53
Glass pipe ASTM C 1053
Polyolefin pipe ASTM F 1412;
CSA B181.3
Polyvinyl chloride (PVC) ASTM D 2665; ASTM F 891; ASTM F 1488; CSA B181.2
plastic pipe in IPS diameters, including schedule 40, DR 22 (PS 200), and DR 24 (PS 140); with a solid, cellular core or composite wall
Polyvinyl chloride (PVC) ASTM D 2949, ASTM F 1488
plastic pipe with a 3.25-inch O.D. and a solid, cellular core or composite wall
Polyvinylidene fluoride
(PVDF) plastic pipe ASTM F 1673; CSA B181.3
Stainless steel drainage
systems, Types 304 and 316L ASME A112.3.1