A derelict religious building near Glasgow will be transformed into an arts venue after more than £4 million of funding was confirmed