"I am not happy with my work." is correct. The adjective "happy" is mostly used with the "with" preposition, and sometimes "about" too.
"I am not happy in my work." may suggest the person doesn't like the place he works in, but I don't think any native speaker would use it.