The Scotland full-back will call time on his nine-year Scotstoun stint after Saturday's Guinness PRO14 grand final at Celtic Park.
Hogg is hoping to depart with a second league winners' medal but Leinster stand in the way as Glasgow look to repeat their 2015 triumph.
Rennie admits he had been forced to tell the "excitable" 26-year-old to calm down at times during the build up to the Parkhead showdown.
But now he wants the rest of his squad to ramp up their effort levels and make sure Hogg goes out on a high.
"We tried to put the brakes on Stuart today," Rennie said after getting his first look around Celtic's 60,000-seater home. "He went berserk yesterday at training, putting in some massive high-speed numbers.
"He's seen that the field is a little bit shorter (at Celtic Park) so he was lining up some kicks from the opposition 22m line type of thing.
"He's an excitement machine. He's desperate to go out on a big note and all we need him to do is to play as well as he has in the last few weeks and hopefully it's enough.
"It would be brilliant for him to end with a trophy. It's as much about the environment, the occasion, and the quality of the opposition too. It's nice that we're at home and we've got plenty to play for as well as Hoggy leaving. I expect to see the boys front up."
Rennie admits his team will have to up their game if they are to get the better of Leo Cullen's team.
"It's hard to accurately say what more we need but we know we can play a lot better than last week," he added.
"We think we can defend better but we were really clinical. That's important in big games.
"I don't imagine we'll get the number of openings we did last week but if we get two or three we need to nail them and that's an area we've been really good at over the last month."