A PSD Web Template is an un-coded web site. It has all the visual elements of the web site including the background, the images, the layout, the typography and more. But there is no HTML or CSS involved.
Each layer will have the different elements for the website. You will have a layer for the logo, the header, the content, the navigation (or multiple layers in a folder) and so on.