Fancy watching opera at one of Europe’s top venues this autumn? Cathy Desmond selects six of the best, from Barcelona to a floating stage on Lake Constance