Feature Request: OTel resource attribute promotion

[yeya24]

Upstream Prometheus Proposal: https://github.com/prometheus/proposals/blob/main/proposals/2024-07-15-otel-resource-attribute-promotion.md

Upstream Prometheus PR Implementation: prometheus/prometheus#14200

AC:

• Add new per tenant configuration for OTel resource attribute promotion and use the configurations in OTLP push handler.

[yeya24]

This can be closed by #6272