[client-v2, jdbc-v2] Client should detect server compression and use proper decompression algorithm

### Description

There is a change in upcoming ClickHouse version https://github.com/ClickHouse/ClickHouse/pull/108786
which switches to ZSTD(3) for disk and network.

In case of HTTP this is compression requested by `compress` query parameter (`decompress` is sent by client to indicate that payload is compressed).

What should be done
- ZSTD compression library is added or existing used
- when client reads payload it should detect magic number of ZSTD and LZ4 sent by server
- if http compression and `compress=1` is enabled it should be possible to read payload from server