Wayne Rooney is looking forward to a "special night" when Manchester United host Real Madrid on Tuesday.