Home price growth in major U.S. metropolitan areas saw a slight acceleration in the annual pace of growth in August, according to a report released by Standard & Poor’s on Tuesday.