The average UK house price hit a two-year high in August, up 0.3% on the previous month, according to new data from Halifax.