The Phoenician (it is not that far from Old Town Scottsdale that a mall, shops, restaurants, bars)
W Scottsdale (walking distance to the mall, shops, restaurants, and bars)
JW Marriott at Desert Ridge (when I stayed there for a conference they had a shuttle that would take you to the Desert Ridge Marketplace with some shops, restaurants, and bars)
The Sanctuary at Camelback Mountain (would need a rental car to get to things, but the location is very peaceful and we went to the restaurant there called Elements when we lived in Arizona)