Wiltshire Council has approved plans for two huge leaf sculptures as part of a scheme for up to 1,000 new homes.