1. Do you want to create an RSS feed OF YOUR site? or 2. just set up an RSS feed into your website from another site's feed?
Anyway, if it's option 1, I do not believe that an RSS feed would work for a static site because the whole point of RSS is sending subscribers updates to NEW content, which is why blogs use RSS so much because they are constantly being updated with fresh content and so the RSS subscribers get notifications via the RSS of the updates. BUT if you update your site regularly it can be a VERY powerful tool.
I use feedburner.com for my rss and there I burn feeds for my blogs and squidoo lenses and hub pages, Haven't tried a static site but I am sure it would work feedburner is top of the line for RSS feed services--It's totally free!
Here is a GREAT guide for creating RSS feeds for a website: www.2createawebsite.com/traffic/create-rss-feeds.html
If it's option 2 then you get the RSS feed code from whatever site you are interested in and then added it your sites code and it will automatically feed on to your site from their site.
Hope this helps!