$hash{site} = $ftp_siebel_dns;
$hash{site}{ip_now} = "x";
$hash{site}{ip_new} = "y";
[download]

That won't work for the same reason the OP's code doesn't work--you're making $hash{site} both a string and a hashref. The other suggestion is good, though.