Always link against cudart_static

[KyleFromNVIDIA]

Description

We want to always build generate_resource_spec with libcudart_static, regardless of what the parent project has set.

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