It does need to be in the tank somewhere, the overflow would be the least intrusive. You are trying to cool the tank water not the sump water.

Steve