The design of a new primary school which will cost Wiltshire Council over £8 million has been unanimously approved.