Use CUDA compiler if available for generate_resource_spec

[KyleFromNVIDIA]

Description

This ensures consistent detection of CUDAToolkit between the main project and the try_compile().

Checklist

• [ ] I am familiar with the Contributing Guidelines.
• [ ] New or existing tests cover these changes.
• [ ] The documentation is up to date with these changes.
• [ ] The cmake-format.json is up to date with these changes.
• [ ] I have added new files under rapids-cmake/
  • [ ] I have added include guards (include_guard(GLOBAL))
  • [ ] I have added the associated docs/ rst file and update the api.rst

[KyleFromNVIDIA]

/merge

[trxcllnt]

Seems like this might have exposed an issue in conda builds? https://github.com/rapidsai/devcontainers/actions/runs/8330706353/job/22795983353?pr=249#step:7:8045

[KyleFromNVIDIA]

https://github.com/rapidsai/rapids-cmake/pull/564 fixed this.