Lion hides the user home directory by default. You can navigate to it with cmd-shift-G easily, but if you happen to want it to be visible all the time just run this command in a Terminal.app window.

chflags nohidden ~/Library

Thanks to Matt Pennig for the command.