Rainfall in August was above average almost everywhere in the UK, with two areas in Scotland receiving up to three times normal rainfall.