Well, for Barcelona I wouldn't worry, for starters Spanish is not even the local language, Catalan is, which in fact is the local language in the whole region of Catalonia (Spanish is co-official though and widely spoken by a chunk of the population) and for those knowing French is far easier to understand/read Catalan as both languages have a lot of similarities.
Nevertheless, it doesn't really matter because in Barcelona -where we have some 18-20% of residents coming from over 120 different countries- English is spoken (or mumbled at least) and is, somehow, a de-facto third language in many places (restaurant menus, the panels at the museums, etc). Same goes for websites. Don't expect to maintain many fluid conversations in English nor that everybody speaks good English, but basic communication is perfectly easy to achieve.
It doesn't hurt though, on the contrary, to learn a few basics in Catalan, you know, the hello-goodbye-thankyou sort of phrases. It's always a good sign of respect to your hosts even if just to throw into a conversation maintained in English. This way you will get even warmer attitudes when trying to communicate with us locals: http://wikitravel.org/en/Catalan_phrasebook
As per mobility (train, metro, buses), all our network here in Barcelona is majoritively based on pictorial signage, which means it doesn't matter which language you do or don't speak. See some examples: http://www.tresdisseny.com/metro-barcelona.html