[HYP-37] First-party support for local dev-mode observability

[MikeShi42]

Often times even locally you need access to traces, metrics, logs, or at least have the ability to preview the telemetry you may be implementing without pushing to prod.

We already do this with our own HyperDX workflow, and it seems like it's been brought up a few times in our HN launch as well for being useful for other people's workflows.

• https://news.ycombinator.com/item?id=37564644
• https://news.ycombinator.com/item?id=37561281

We should figure out what requirements should be part of making HyperDX local-friendly, a few things on the top of my mind:

1. Optimize for resource footprint over scalability (we can tune the memory usage of the otel collector, maybe remove the miner or spin it up on-demand, etc)
2. Auth-less flow, so users can just spin up a container and start sending telemetry to the Otel ports directly without any additional auth/key/team setup.

Kicking off this issue to collect any other requirements and stub out additional tickets along the way.

_HYP-37