Hi Jo-Anne,
In July it's the "presentación" of Real Madrid, showing the new players to fans, and doing a training with a little match.
The Bernabéu's Trophy is at the very end of August (or at the begining of September).
Other than this, I don't know if you can get inside the stadium. But I suppose that you can see the Trophys Room with all the Europe Cups...
The stadium is quite centered (a little bit to the north) in the city of Madrid. There is even a Metro station called Santiago Bernabéu to get there (formerly it was called Lima station) in line 10.
You can get more information at the official Real Madrid web site:
www.realmadrid.es Hala Madrid!!!