Fife is recording some of the lowest groundwater levels on record - sparking a warning as we head into the hottest spell of the year.