I think Rooney will stay at Utd.
But if he were to go, count Liverpool and Spurs out. I doubt Liverpool can afford him - they're not out of the woods yet, and I doubt he'd want to go there.
As for Spurs, they throw cash around like the best of them, but Levy and co have been a little more sensible with their money recently, and their board have been very vocal about living within their financial means. I just dont see it as a fit.
Would he go to City? Doubt it, but depends how pissed off he is with Fergie. I think it'll get resolved, Utd can't lose Rooney.