search around for photoshop filters

however, anything like this is probably going to cost money
and probably won't yield spectacular results

you can't magically make a bad picture good
if the details not there to start with, you're screwed

depends on how out of focus it is
maybe helpful to post the pic up here
just so we can have a look