A Solihull secondary school and sixth form has been given the go-ahead to build a new floodlit artificial sports pitch.