Fix CMake library probes for libraries not on the default linker path

On machines where snappy, zstd, and such are not on the default linker path (e.g. they're in /usr/local or /usr/contrib or /usr/pkg or /opt or whatever) the current cmake configury fails to find them.