Add support for signoz metric provider

[npv12]

Describe the feature

We have providers made for prometheus. While it allows for custom url and headers, body format is fixed and differs from what signoz expects in https://signoz.io/docs/metrics-management/query-range-api/

Proposed solution

Create a new provider which would support for signoz

Any alternatives you've considered?

No, but this in my opinion should be the go to way

I am more than happy to help build it out, will be opening a new MR for the same soon.