I followed the water guide on steampowered (I'd reply there but they closed the SDK forum for some reason), but when I load my map into CSS the water looks like the void
I'm experimenting with this too. From what I've found, the void effect for the water only occurs when you make it an even or higher level with the ground. I put the water brush down 16 units from the ground and it refracted fine.