Add range based dictionary to CHANGELOG + tests

[rjoelnorgren]

Summary

Following up on https://github.com/ClickHouse/dbt-clickhouse/pull/361#issuecomment-2446490479.

Checklist

Delete items not relevant to your PR:

• [x] Unit and integration tests covering the common scenarios were added
• [x] A human-readable description of the changes was provided to include in CHANGELOG