Sites like Subtle Patterns and Transparent Textures are a good source of mostly transparent patterns you can put on your sites.
These can be more of less subtle. But they all help make a site feel a bit more interesting to me than a full plain color background.