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?

• fix: update CI/CD process to use composite actions and auto-release workflow terraform-aws-rds#361

[antonbabenko]

This PR is included in version 4.8.0 🎉

[github-actions]

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.