How do I open a bank account as a foreigner?

Which banks accept foreign residents, what documents are required, and are there fees I should know about?