Add checks for systems where linking to atomic is required

[nightlark]

For getting the Yggdrasil package updated to 3.6 (#2716), a patch to link against -latomic on some platforms was needed -- specifically they've added riscv64 binaries to the build matrix for Yggdrasil, and there were undefined reference errors to __atomic_compare_exchange_1, __atomic_fetch_or_2, __atomic_fetch_and_2, __atomic_compare_exchange_2, __atomic_fetch_add_2, and __atomic_fetch_sub_2.

Ideally I think we'd use some combination of https://cmake.org/cmake/help/latest/module/CheckLibraryExists.html and https://cmake.org/cmake/help/latest/module/CheckSourceCompiles.html#module:CheckSourceCompiles -- and this would also remove the need for the PI specific build configuration option.