My son is 10 and has Aspergers, and all indications are that he will do very well in this world. What our children need most is the space to develop in their own unique way, and not on the same time frame or with the same expectations as nuero-typical children. Many ASD children have sensory issues, and sensitivity to these triggers is also important. Much of your job as a parent will be about unlocking the doors to what makes your unique child tick, and you have just been handed the first set of keys. Use them wisely. Read, learn, and tune into your unique child. The more you understand him, the more you can help him.
Our children will learn to accomodate for their weaknesses, and will find their road. With our help.
I have participated in various forums for Aspies that have helped me a lot. Hearing what someone who grew up ASD has to say is really insightful. One such forum is wrongplanet.net. Even though it is an Asperger's community, many high-functioning autistics are members. I think you can find answers to many of your questions there.
I will ask you to look at your child as someone with unique needs, and not someone who needs to be "cured." While it is definitely worth exploring dietary issues, since many spectrum children do seem have their conditions complicated and magnified by food allergies or digestive issues, I am not a fan of many of the other treatments and theories some parents advocate, as they cause a lot of stress to the children, and are not scientifically sound (this is the type of input I have found in forums with teens and adults on the spectrum). Your child can thrive by being in environments that suit his unique needs, and by being allowed to use self-calming behaviors that may seem odd to us, but are very important to him. What you want more than anything is a happy child, and when you do not have that, it is time to look and listen to figure out what isn't working for him, and what is causing stress.
With my son, I have found that behavior issues are always connected to stress. If I can find out what that stress is, and mitigate it, then the behavior problem goes away. Stress can come from odd places with an ASD child: my son fears the flushing of toilets, for example. Locating the stress points ("triggers") is not an easy job, but it is essential, and probably the single most important thing you will be doing as the parent to an ASD child.
Many schools in the Bay Area have experience with ASD children and do an excellent job. If you don't feel your son is served well in the school where he starts, you should be able to find some solid options.
Finally, as another parent pointed out, consistency is very important for our children. Consistency has never come naturally to me, but I have learned to work on it, for my son needs clear and consistent expectations and scheduling to thrive. And it IS important to continue to hold high standards for your child, as also pointed out by another poster. Just be very careful to separate what your child really can do, from what you think they can do, because most ASD children react very poorly to stress and frustration.
I wish you both the best of luck.