Bright swimming pools, split-level residences, and suburban Californian landscapes by David Hockney are an odd mix of tranquilly and excitem