Zero chance of him going to City.
There's been stories about Bayern, Chelsea and PSG. Arsenal too, though to a lesser extent. Apparently after we won the league, he told SAF he wanted to leave. Their relationship has never been the same since Rooney publicly questioned United's ambition (SAF thinks loyalty = king). That's why SAF so often has a go at him in the press and drops him. He's no longer a favorite.
Anyway whether or not Rooney stays or goes is entirely up to Moyes. Rooney has 2 years left on his contract so he'll either sign up to a new one at a wage decrease or be sold on.
There's a lot of stories suggesting Moyes will go straight in and buy Fellaini and Baines
edit:
Read some other stories today saying that SAF told all the players he was leaving 2 days ago at a golf day. He got emotional when telling his backroom staff because he knew it would result in many of them losing their jobs as Moyes will probably bring in 1 or 2 of his own staff. Mike Phelan will probably be the first casualty.
Lot of rumors saying Phil Neville will return as coach, though I'd be surprised at that as he hasn't retired yet.