You're looking for the as property:

https://react-bootstrap.netlify.app/docs/getting-started/introduction#as-prop-api

So your code becomes:

<Container as="header" className="main-header">
  <Row>
    <Col sm={6}>
      Some content here
    </Col>
  </Row>
</Container>