New community football pitches will be built next to a major housing development on the outskirts of Newport, under a deal between the builder and city council.