To filter and sanitize
enough that you won't end up with stinky water is tricky. Most people I know that have tried end up giving up because they could never sanitize sufficiently to eliminate the odor.
Theoretically a slow sand filter done right can purify the water sufficiently that it might even be potable. In practice? I dunno. When people say slow, they really mean it. BTW, I found this quite interesting:
http://en.howtopedia.org/wiki/How_to_Filter_Water_with_a_Sand_Filter
But your thinking around the UV gives me pause. First, UV only works when the water is quite close to the bulb, which limits how much you can do (and yes, wattage does matter). In a vessel of even a few gallons it won't sanitize all the water unless it's continuously circulating -- you can buy inline UV filters for this purpose, but they always seemed outrageously expensive to me. Maybe you can find one cheap. If you ask me, UV sanitization systems are hugely over-rated and frought with difficulties but my
experience with them is limited. I do have a lot of experience with ozone, which might be an option if the UV doesn't work out.
If I were in your shoes (and not wanting strictly potable water) I'd find an old pool sand filter and see what happens just with that. If there is odor then look at your options.