Scottsdale, mainly north Scottsdale, is considered one of the wealthy areas of the Phoenix valley. It is very popular for winter visitors and so it has multiple resorts, restaurants and golf courses. Some of those facilities are on the expensive side. Lodging prices are much higher in the winter tourist season.
Scottsdale used to call themselves the West's most western town, but that was years ago. Back then, downtown Scottsdale did not allow traffic lights and all buildings had to have a western front. Good or bad, all of that has gone by the way side and most everything is now new modern buildings.
I really can not recommend any place specific because I have lost track with so much change. The hotels and resorts change ownership all the time. The internet travel sites should have the most current information.
July and August are hot with some humidity from the summer monsoon storms. It is not uncommon for the nightly lows to be in the low to mid 90's. The nights start to cool off some around the first part of September. The hottest day on record for Phoenix was June 22, 1990 at 122 F. Figure around 106 to 114 for July and August. Today was an exception and it only reached 98 F at my place.
The birds are up with the sun in the hot summer. Activity dies down soon and the birds go were ever they can find shade. Activity picks up late in the day. Most common are White Winged Doves, Mourning Doves, Gambel Quail, Curved Bill Thashers, Abert's Towhee, Sparrows, hummingbirds, finches, Verdins and more. I have some Hooded Orioles hanging around this summer. eBird is a good reference to see what is where and when.
The Scottsdale area is highly developed so there is not a lot of natural terrain. Indian Bend Wash runs south through the area. It has been developed with green belts and golf courses and it contains many small man made lakes. The problem is there is not much natural vegetation so the shore line offers little cover. These ponds hold a variety of ducks in the winter but not so much in the summer. The ducks start arriving around the end of September and most are here by December for their winter stay.
There are several desert parks with easy hiking trails near by. Those are areas to possibly see a variety of birds while hiking around. It will mostly be one of those deals were you will see one bird here, and couple over there, etc. However it can get extremely hot so you want lots of water and do not range to far from the car. It is important to respect the desert in the summer.
The best place to see a good variety of birds year round is the Gilbert Water Ranch in the south east part of the valley. This a manmade riparian which is used to recharge the water table. It should be about a 30 to 40 minute drive from north Scottsdale during non rush hour and is mostly freeway to get there. However parts of that freeway is under major construction right at the moment.
http://www.gilbertaz.gov/departments/parks-and-recreation/riparian-preserve-at-water-ranch/birds
Another spot to go that is closer is the Desert Botanical Gardens just south of Scottsdale. They do charge a pricy daily admission but the plants and feeders attract a good variety of birds. The best time is early morning.
http://www.dbg.org/
Just to the southeast of the Gardens are the Papago ponds which I enjoy checking out in the summer. There is natural growth along much of the pond shore line which is better than the green belt ponds in north Scottsdale. The ponds are surrounded by desert terrain so chances are good to spot some desert birds. There are easy hiking trails.
https://en.wikipedia.org/wiki/Papago_Park
The best birding out of the Papago Park ponds for me is the Evelyn Hallman Park pond in the south east corner of the park. I walk the outer perimeter of the lake and the island. You will usually find a variery of brown birds, and some water birds in the pond, such as Mallards, Grebes, Coots and sometimes more. There are also hawks hanging around along with some other occasional birds. There may also be some migrating species at the end of August.
Here is a great web site discussing birding locations in the general area....
http://www.birderfrommaricopa.com/new-page-2.htm
This was put together by Tommy D and he also has an excellent birding blog covering his outings in Maricopa County. It may be worth while to look over entries for around the time you would visit just to find out what he was seeing in the area.
http://tommysbirdingexpeditions.blogspot.com/
Scottsdale is a beautiful area with some great views of the surrounding desert mountains. Summer may not be the best time out here for birding but there are still plenty to see if you are willing to adjust to the summer environment. I suspect you would find plenty to do so long as you can contend with the heat during the summer. The good news is that everything other than the outdoors is air conditioned so it is easy to get relief.