CSS Zen Garden is my favorite inspirational site. Really blew my mind to see how many completely different types of pages could be created with the same HTML. It brought home the message that CSS was all about how something looked while HTML is the content.
When you're ready, I invite you to check out csszengarden.com. Although some of the techniques are older, the designs are awesome.