Configuring these stylesheets is a piece of cake.
Download, save and unpack the CSS files anywhere.
For the aero image background; open up opera:config, search for "Image Style File" and set the new image.css as the userstyle.
NOTE: This userstyle comes with two tiny image files, keep this one as a folder.
Here's an example of the opera IRC client with the aero stylesheet: