You can estimate a groundwater level from CPT data based on review of pore pressure data as GeoEnvGuy says, however when dealing with Clays, just because there is an increase in pore pressure in the layer it doesn't guarantee that that layer is below the water table.
In Sands any increase in porewater pressure is most likely due to groundwater level (or a purged water table).
You ideally should have a monitoring standpipe to determine the groundwater level or at least some groundwater level data from boreholes. Even though groundwater level from a borehole is likely affected by drilling fluid, if used.