CTest: Avoid invoking external tool to get the host name

Populate the SITE cache entry using an internal query instead.

While at it, document the ctest_site command's use of the HOSTNAME variable. This change technically breaks compatibility by removing that behavior from the CTest module, but it was undocumented and platform-specific.