CPack/RPM: Add zstd compression support

Add support for using Zstandard compression with the RPM CPack generator.

Also improve error handling to ensure an invalid value provided doesn't just fallthrough and fail silently.

Fixes: #26088 (closed)
Topic-rename: cpack-rpm-zstd-compression