There are so many great neighborhoods in the Philadelphia that offer what you asked.
It really comes down to how much you want to spend.
Here are some areas that I think have all you asked for and more; Old City, Northern Liberties, Society Hill, Queens Villege, Bella Vista, Washington Sq (east & west), China Town, Fish Town, Ritten House Sq, Fitlers Sq, Graduate Hospital Area (SWCC), Fairmount, Passyunk Sq and Passyuk Crossing. And I can come up with some me but I think this may be enough for now.
Philadelphia is a big city but it is very easy to get aroud in it. Philly has alot to offer as far as Restauants, bars, art, and the best of city living.
I live and work here and I guess you can tell I am a fan of my home town!
I am sure you will make a choice you will be happy with. Good luck with your search!