Councillors have approved a scheme to to put up powerful lights around a school sports pitch despite residents concerns over glare.