Add support for golang auto-instrumentation

[pavolloffay]

The https://github.com/keyval-dev/opentelemetry-go-instrumentation could be used for golang auto-instrumentation.

From the object management perspective it would be better if the project was part of the CNCF/OTEL community.

cc) @edeNFed

[pavolloffay]

Golang auto-instrumentation has been donated open-telemetry/opentelemetry-go-instrumentation#2

[TylerHelmuth]

@pavolloffay @open-telemetry/operator-maintainers @open-telemetry/operator-approvers if the community is willing, I would like to start working on this.

[edeNFed]

@TylerHelmuth I'll be happy to help if needed

[TylerHelmuth]

@edeNFed sounds good! I'm sure I'll have some questions once I get started.

[TylerHelmuth]

Please assign this to me.

[TylerHelmuth]

Question: will we want to build our own version of the go auto-instrumentation agent like we do for the other languages or will it be acceptable to use the image published by opentelemetry-go-instrumentation?

[TylerHelmuth]

As discussed in the SIG meeting today, we'll move forward with using an image published from open-telemetry/opentelemetry-go-instrumentation instead of building our own. This decision is made based on the increased complexity of the go auto instrumentation due to eBPF and the necessary offsets json file we would have to manage if we had our own image.