As a Scottsdale resident, I can recommend a few spots for food/nightlife/etc.
There's two sides of Old Town when it comes to bars, there's clubby Old Town (your Whiskey Row, Bottled Blonde, El Hefe area), and then your more laid back Old Town (Pattie's, Grapevine, Boondocks, Gilligin's, Coach House). In clubby Old Town, you'll get a lot of loud club music, usually packed to the brim with people and lines out the door, girls in little clothing dancing on the bars. Whereas in the laid back side, Pattie's has pool and shuffle board, Gilligin's has beer pong and Jenga, Boondocks has cornhole, Jenga, pool and a large patio, and Grapevine is good for some karaoke.
Mill Ave in Tempe is much like clubby Old Town but with more college kids. They do have a great dueling pianos bar called Low Key.
Food: GratefulBuck mentioned Pizzeria Bianco, there's a few locations. I haven't been to the original downtown but there's one in the Biltmore area I have been to which is a short drive from Scottsdale. As for food in Old Town, Cold Beers and Cheeseburgers is a good sports bar, The Breakfast Club is great for (you guessed it) breakfast, I'm a big fan of Barrio Queen and their Mexican food and margaritas.
Any other suggestions and I'd be happy to help!