Install this to server
http://www.subsonic.org/pages/index.jsp

And configure it. I think that it´s possible to configure layout that is more appropriate to small screen. And acces to your server with n900 web-browser and set it in jukebox mode.

.edit
btw. Does knots2 have this kind of mode?
http://maemo.org/packages/view/knots2/