A memorial service marking the death of eight soldiers killed in a Wiltshire explosion will be held in Marlborough.