Resolve "fix(build): make build compatible with projects using CUDA"

Description

This makes the build of Sight compatible with repositories using CUDA. sight_add_target is now capable of compiling .cu and .cuh files.

Closes #1114 (closed)

How to test it?

Build with a repository using CUDA.