I have stayed in a cabin in curry village, which was barebones but fine. I think a lot of the tent cabins are or were closed because of the hanta virus outbreak. If money is no object, go for the ahwahnee. I think Yosemite Lodge would be nice too - it's much cheaper than the ahwahnee and they have a cafeteria and other stuff for the family.
You could also tent camp.
BTW this is the site for booking lodging in the park:
https://gc.synxis.com/rez.aspx?Chain=398 Looks like Yosemite Lodge is booked for all but a few nights in August. And for your first trip I would definitely recommend being in the park. The geography is so stunning and it's amazing to wake up and be at the base of half done, etc. Depending on what you're planning to do you may not want to spend 45 minutes in the car every day to get to the valley - which is what you'll be looking at if you stay anywhere besides the valley.