But how hot does the heat source have to be?

Depending on the needs, resistive heating can get hundreds of degrees hot, but the best heat pumps that I know of can only raise the temperature about 60 or 70° f.