Footage shows a large fire at an “iconic” Scottish church building, which has been “a place of special memories” for locals.