Scottsdale (old town) >>>>> Anywhere in Phoenix
If you are young then Scottsdale Entertainment district will be rocking even in August
Valley Ho has a great location (walkable to Old town) and will be way cheaper than Phoenician
W hotel has a cooled pool and is fun. Top destination of the beautiful people.
The more you share the better targeted advice you will get.