Make the release process fully happen within GitHub Actions

[mx-psi]

We want to automate the release process using Github Actions. We can do this step by step:

Releasing opentelemetry-collector:

• Automate release Step 1: make update-otel
• Automate release Step 2: deciding whether a release for stable modules is needed
• Step 3 is automated
  • Automate halting merging in core with a CI check #11707
• Automate release Step 4: pushing release branch
  • This may not be possible because of GHA permissions
• Automate release Step 5: pushing tags
  • This may not be possible because of GHA permissions
• Step 6 is not applicable
• Automate release Step 7: adding changelog contents to Github release

Releasing opentelemetry-collector-contrib:

• Automate contrib release Step 1: Bumping version
• Step 2 is automated
  • Automate halting merging in core with a CI check
• Automate contrib release Step 3: pushing release branch
  • This may not be possible because of GHA permissions
• Automate contrib release Step 4: pushing tags
  • This may not be possible because of GHA permissions
• Step 5 is not applicable
• Automate contrib release Step 6: adding changelog contents to Github release

Producing the artifacts:

• Automate artifact release Steps 1, 2 & 3: [chore] add update version automation workflow for artifacts release opentelemetry-collector-releases#684
• Automate artifact release Step 4, 5 & 6: pushing tags
  • This may not be possible because of GHA permissions
• Automate artifact release Step 7: ensuring new artifacts are available