[release] Automate version bump and changelog generation in release

[emmyoop]

Housekeeping

• I am a maintainer of dbt-common

Short description

Right now we manually bump the version on release and never generate changelogs.

Acceptance criteria

version bump is automated in release
changelogs are auto generated in release
changelog notes gets posted to the github release

Suggested Tests

manual testing

Impact to Other Teams

None

Will backports be required?

No

Context

See release in dbt-core and adapters for how this is currently done. It will vary because we're using hatch here instead of setuptools. dbt-postgres and dbt-adapters both use hatch - they may be good examples

[emmyoop]

duplicate of #92