Support snapshot_meta_column_names

**Is your feature request related to a problem? Please describe.**
Dbt docs describes a feature to customize the names of metadata columns in a snapshot model (introduced in dbt v1.9)
https://docs.getdbt.com/reference/resource-configs/snapshot_meta_column_names

**Describe the solution you'd like**
Use the clickhouse adapter with this feature.

**Additional context**
I start to developp a custom macro to get that feature in my project, I think I can make a PR if adding this feature is relevant

Start with the linked dbt documentation for snapshot_meta_column_names and review the custom macro mentioned in the issue. No repository file, test, or entry point is named, so first identify where dbt-clickhouse implements snapshot behavior and how adapter macros are tested. Done means the ClickHouse adapter supports the dbt v1.9 configuration with coverage for customized metadata column names.

Written by the indexing model from the issue text.