Once you "jailbreak" an Apple TV (Gen2), then the option to install 3rd party applications is available.
Apparently the new Apple TV uses iOS4 and many of the tools and 3rd party applications will be semi-compatible.
This is in early stages, but seems to be developing fast.
Porting z-Subsonic to be used on an Apple TV would be great!