Use Atomic Database by Default in clickhouse-local

Why it matters

This change addresses issues related to the default database behavior in clickhouse-local, specifically improving support and consistency by using the Atomic database engine by default. It resolves problems described in issues #50647 and #44817, enhancing data reliability and atomic operations in local ClickHouse instances.

How to use it

When running clickhouse-local, the environment now defaults to using the Atomic database without additional configuration. Users can execute queries and perform operations benefiting from the Atomic engine's features out of the box.