fix: update CI/CD process to enable auto-release workflow

[bryantbiggs]

Description

• add new hook to pre-commit to fix eof lines
• add new release.yml workflow. this workflow will automatically:
  • create and push new tag for next semver based on conventional-commits
  • create GitHub release with notes
  • update Changelog with release notes
  • this workflow will also automatically notify PRs that are included in the release, mimicking the manual behavior but now its automated https://github.com/clowdhaus/terraform-aws-rds/pull/1#issuecomment-952097291
• remove old chglog configs and Makefile

Motivation and Context

• automate release process in a standardized manner
• standardize new CI workflow (copying from RDS Aurora)

Breaking Changes

• No

How Has This Been Tested?

• [x] https://github.com/terraform-aws-modules/terraform-aws-rds/pull/361

[antonbabenko]

This PR is included in version 2.11.1 :tada:

[github-actions[bot]]

I'm going to lock this pull request because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues. If you have found a problem that seems related to this change, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.