Unity can make games for PS3 , WII , 360 and Wii U but for these consoles , you'll have to a professional and deal with nintendo , microsoft and sony no matter if you have Unity Pro or not. So unless you can shit money , that will be near impossible.
Unity for consoles is only available for companies that have become approved developers by the respective platform holder.
However if you want to make games for Ouya , it's like developing for Android so yeah you can make Android & Ouya games with Unity. I don't use Unity because i just don't feel like i "own" the games i'm making , i hate when they do that. A good option to easliy make games for Ouya is to buy Game Maker studio , Locomalito did this for his games