Plot: Andrew Graham-Dixon reveals how the north of the country has produced some of the most dazzling and iconic art of the modern age. Spain's turbulent history has shaped artists from Francisco Goya to Pablo Picasso