Can an AppleTV wake a Snow Leopard Mac for playing back iTunes content?
You have to setup your mac to wake from sleep on the wifi. It all depends on the model of your machine whether its capable of doing this or not. You can read more about setting this up on your mac at the following KB article at Apple. 

http://support.apple.com/kb/HT3774