As far as touristy stuff goes, you'll definately want to check out our many museums. Museum of Nature, War Museum and Museum of Civilization in Hull seem to be the most popular. We also have the Aviation Museum which is fun.
You may also want to spend an afternoon wandering around downtown Ottawa and the Byward Market. Take a tour of Parliament Hill or one of those bus tours that take you around the core area if you want.
There's also a tonne of pretty good restaurants in the area, and I would recommend a bike ride along the Rideau Canal. You could even tool around in The Glebe if you wanted.
As far as the not so touristy stuff, go to bars in Hull and Aylmer in Quebec and have some good ole fun. Or even Elgin Street here in Ottawa. The Byward Market is also a good club scene at night.
As far as the ugly, just hang around the Rideau Centre and Rideau Street after eight o'clock, and you'll see the bad...