As far as hotels go, ideally, you want to be downtown or on the North Shore because it'll make getting around easier. If these areas are too pricey, try Southside Flats, Oakland or Shadyside. Staying outside the city, near the airport or areas like Greentree are going to be a pain in the ass if you plan on drinking seriously.