For cycling/hiking/camping, looking into Ohiopyle... about 45 minutes from Pittsburgh (it's not in Ohio). There are trails around the rivers though and Pittsburgh has four main parks... Schenley and Frick will be close to you at CMU/Sq Hill. There's also Highland and Riverview on the North Side. Riverview Park also has an Observatory (in the neighborhood Observatory Hill... my 'hood!). There are lots of smaller parks as well like Point State Park.
Squirrel Hill area is very nice, you shouldn't have any problems there. Very pretty older houses and lots of restaurants/things to do. Pretty sure going to CMU you should get a free bus pass. Transit system is pretty straightforward. If you use it in Philly you should be fine here.
I'll guess I'll just list some cool stuff to check out...
-Cathedral of Learning at University of Pittsburgh (check out the Nationality Rooms on the first three floors)
-Phipps Conservatory
-There are good breweries popping up. Grist House in Milvale, Allegheny City Brewing in lower North Side, East End Brewing Co in the East End, Arsenal Cider House in Lawrenceville
-Take the inclines up and down Mt Washington
-St. Nicholas Church in Milvale has these INSANE murals inside. I'm not religious but found it super fascinating. It's one of the coolest tours you can take.
http://vankamurals.org/ https://solararray.files.wordpress.com/2014/10/injustice-maxo-vanka-_-spmmmv.jpg
-National Aviary on the North Side
-Catch baseball at the amazing PNC Park (Phillies @ Pittsburgh next month if you'll be here)
-if you are into art/museums there are some cool ones... Mattress Factory, Andy Warhol Museum, Carnegie Art/Natural History/Science Center
if you have anything specific you were wondering (types of foods, music venues) let me know and I'll try to answer.