If you want to upgrade an existing machine, your money is probably best spent on I/O - for fast random-access seek time disks - and buying extra RAM.
Squid is not CPU-intensive, and a multi-processor machine tends to be wasted as a Squid proxy.