FindHDF5: Find C component with only CXX compiler

For CXX-only projects it is sometimes useful to detect the C component even with just a CXX compiler.

Fixes: #24241 (closed)
Topic-rename: FindHDF5-C-with-only-CXX