[Meta] Add auto github release workflow

[saratvemulapalli]

Is your feature request related to a problem?

As part of OpenSearch releases, opensearch-build pushes a tag for the release commit.
But publishing a github release based on the tag is manual.

What solution would you like?

We've added this workflow[1] in OpenSearch which publishes github releases automatically when a tag is pushed.

Add this workflow to all repos releasing software in the project.
See example: https://github.com/opensearch-project/OpenSearch/blob/main/.github/workflows/auto-release.yml
Example Release: https://github.com/opensearch-project/OpenSearch/releases/tag/2.5.0

• Add auto github release workflow alerting-dashboards-plugin#480
• Add auto github release workflow alerting#791
• Add auto github release workflow anomaly-detection-dashboards-plugin#420
• Add auto github release workflow anomaly-detection#807
• Add auto github release workflow asynchronous-search#234
• Add auto github release workflow common-utils#356
• Add auto github release workflow reporting#642
• Add auto github release workflow dashboards-visualizations#162
• Add auto github release workflow index-management-dashboards-plugin#609
• Add auto github release workflow index-management#683
• Add auto github release workflow job-scheduler#315
• Add auto github release workflow k-NN#760
• Add auto github release workflow notifications#615
• Add auto github release workflow performance-analyzer#381
• Add auto github release workflow performance-analyzer-rca#292
• Add auto github release workflow security-dashboards-plugin#1324
• Add auto github release workflow security#2435
• Add auto github release workflow sql#1336
• Add auto github release workflow observability#1406
• Add auto github release workflow cross-cluster-replication#703
• Add auto github release workflow ml-commons#726
• Add auto github release workflow geospatial#219
• [FEATURE] Auto release the repo once a new tag is created opensearch-dashboards-functional-test#788

[1] https://github.com/opensearch-project/opensearch-plugins/blob/main/WORKFLOWS.md#auto-github-releases

[peternied]

This campaign looks like a good candidate for being deployed via a workflow management tool like the one described in this issue

• [FEATURE] OpenSearch-Project workflow manager .github#113