Like picture in picture, I want a 'always in front' spaces in spaces. So if I am working or programming in one space, I can see another space that may be playing a video on the bottom right corner. Is there such thing?
If you want to see the contents of one space in another space, there is no such feature in Lion, and I'm not aware of any applications that may enable it.
All in all, such “feature”, if it existed, would have given me a bizarre feeling, akin to remoting into my own computer. Why would I ever want to do that? It would be impossible to control another space with a mouse (scaling issues) so watching a film would be a pain.
You want to code and watch a movie at the same time? (Sure it's a good idea?)
Some media players (amongst them is MPlayerX, the most polished OS X player) always stay on top when playing so you won't have issues with window disappearing as soon as you switch the focus.
Finally, if you want a window to stay visible regardless of chosen space, right-click its Dock icon and assign it to All Desktops as advised by Andrew in the comment to your question.
Check out afloat. Link: http://infinite-labs.net/afloat/ It lets you "float" one window above others, and customize its appearance to a degree (eg. opacity). May be what you're looking for, but I'm not really sure, as your question is a tad unclear, at least to me.