Council planners have backed proposals for two new all-weather sports pitches in Caerphilly County borough, paving the way for around £2 million of investment.