National Grid substation damaged in transformer fire