New MV Implementation - Adapter and Metadata Layer Updates

### Description

* Update `dbt-clickhouse/dbt/adapters/clickhouse/impl.py` to recognize new relation types.

* Ensure `list_relations_without_caching` and related macros detect both MVs and target tables properly.
