[Tech Debt] Establish a separate changelog process for `dbt-tests-adapter`

[mikealfare]

Is this a new bug?

• [x] I believe this is a new bug
• [x] I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

Changelog entries are co-mingled for dbt-adapters and dbt-tests-adapter, despite these packages being released independently. Additionally, the linked issues don't appear to be populating.

Expected Behavior

Setup a separate changelog process inside of ./dbt-tests-adapter to manage changelog entries and the consolidated changelog:

|___ ./dbt-tests-adapter
    |--- ./changes
    |--- dbt/tests/adapter
    |--- CHANGELOG.md
    |___ pyproject.toml

Steps To Reproduce

Look at the current CHANGELOG.md, notice that it contains changes for a version 1.1.0 (dbt-adapters) and a version 1.8.0 (dbt-tests-adapter).

Relevant log output

No response

Environment

• OS:
• Python:
• dbt-adapter:

Additional Context

No response