Look at the Westin Kierland, next to Kierland Commons and Scottsdale Quarter, walking distance if you like. Up the street at Scottsdale Road and Bell Road are an assortment of chain hotels, Springhill Suites, Residence Inn, Courtyard by Marriott, Sleep Inn, not walking distance but a 5 min drive. Also close by is the Fairmont Princess and Zona Resort & Suites. Those two "malls" are outstanding for shopping and dining, neither have a ton of night life, but there are places that are open at night and stay busy.
Also, any of the hotels in downtown Scottsdale would fit your needs, pretty much unlimited shopping, dining and entertainment, look near Scottsdale Road and Camelback. There are nightclubs in abundance in the downtown area, so depending where you stay, noise might be a problem at night. Take a look at Firesky, Chaparral Suites, Doubletree Paradise Valley Resort, Holiday Inn Express to name a few.
Edited: 5:59 pm, November 18, 2012