[CMake] Add check for Valgrind's memcheck.h

Re-enable Valgrind support which was accidentally dropped together with the Autotool's build system.

(cherry picked from commit 288ac351)

Conflicts: config.h.cmake