[BUG] nvcomp is not properly linked when libcudf is build as part of cuDF Python

[vyasr]

Describe the bug
When building cuDF Python with FIND_CUDF_CPP=OFF, the build succeeds but the resulting package is not importable. When an import is attempted, it will fail with a linker error indicating that libnvcomp.so is not found. We currently work around this behavior for wheels using a CMake helper function, but ideally this would not be necessary. We should determine why the library paths are not automatically being set correctly. We may just be missing some install rules.

Steps/Code to reproduce bug
Run python setup.py build_ext --inplace -- -DFIND_CUDF_CPP=OFF in the python/cudf directory.

Expected behavior
The above command should generate an importable source directory and not raise any errors

[vyasr]

This may be fixed by setting the INSTALL_RPATH_USE_LINK_PATH CMake property

[vyasr]

There's nothing to do here. We use EXCLUDE_FROM_ALL, so it's expected that libnvcomp won't be installed. rapidsai/rapids-cmake#597 and rapidsai/rapids-cmake#602 ensure that if we did install, libnvcomp would be installed alongside libcudf, which would allow libcudf to see libnvcomp since its RPATH is set to $ORIGIN by default. Once #15483 is done we'll handle installation of these together correctly into a single C++ wheel that can be reused by Python wheels.