United_Flyer3,

If you're renting a car, I would look at staying in the Old Town Scottsdale area. It's not a far drive from Tempe, and the area has plenty of nightlife(Sugar Daddy's, Sandbar, etc).

I stay at a number of hotels in that area. The Hilton Garden Inn Old Town is a great hotel. It's within walking distance of many bars and restaurants.