Udpate dependencies and fix docker based CI tests

Upgrade dependencies, primarily to align ClickHouse client with more recent CH server versions.

Fix the E2E/integration tests CI setups. This involves making sure the testcontainers API is used to retrieve hosts/ports rather than assuming localhost.

A few minor changes too:

• add .tool-versions for asdf users.
• centralize CH replicated config.
• use go.sum file as gomod cache key in CI.