The best is to add the tag just before your </body> at the bottom of your pages.

You can generally edit your website templates and add this code in a "footer" file.

For advanced users, please check out the Piwik Javascript Tracking documentation.