Migrate from JIRA and setup project management on GH

Discussion: https://github.com/apache/hudi/discussions/13877

This issue tracks all the work involved in moving Hudi project management seamlessly from JIRA to GH.

Below is a tentative list, that will turned into sub-issues as things get unblocked

- [x] https://github.com/apache/hudi/pull/13907
- [x] Add new relevant labels to GH ones
- [x] Define the correct issue types, milestones inside GH
- [x] Change the Issue creation template and other GH templates
- [x] Update contribution guide and how-to-contribute https://hudi.apache.org/contribute/how-to-contribute with new workflow and rules.
- [x] Define allowed values for scope
- [x] https://github.com/apache/hudi/pull/13883
- [ ] Cleanups
- [ ] Release process and guide changes around stuff relying on JIRA
- [ ] GH projects for tracking epics, stories, issues, PRs. Support vs Dev tasks.
- [ ] Back label all old support issues with `community-support`
- [ ] Replace all links in site to JIRA.
- [ ] Cleanup existing labels
- [ ] Mark issues with right components, backfill
- [ ] Mark new [first issues](https://github.com/apache/hudi/issues?q=state%3Aopen%20label%3Agood-first-issues) for newbies

See sub-issues for more scoped tasks..