As an addition to this, the Air Video app will not play content that has DRM on it (basically, any TV shows or movies purchased or rented through the iTunes store)
File Browser. File Browser let's you view and open network shared files, to include audio and video. While your computer needs to be on, no sever software is needed.