English is more than enough for Amsterdam.. and the liberal "parts" you have to seek out yourself to be offended by.. if you just visit the city like you would any other it will be just like any other..
Being against drugs myself I just made sure I didn't enter any cafes with a palmsign in front or with rastafarian types with a blank stare hanging out