Knaresborough to be backdrop of this Sunday's Songs of Praise