What is the name for this round metal drain cover?
Sump cover. Technically what you have is a Rainwater Collection Cistern, so Cistern cover, Cistern access cover or Cistern hatch cover all would apply.