My water department has asked me about visualization of groundwater plume models. I have no idea where to start. All the links refer me to Cameo/Aloha but these are for Atmospheric modeling as far as I can see. Has anyone any experience with point source plumes in groundwater? I guess the models are similar to those from atmospheric contamination models but I also need to understand which variables are necessary for a successful model.
Ground water modelling is generally not visualized within what most people would consider to be GIS software. The more common term in the field is simulation software.
Now, the software you would use would very much depend on exactly what you are trying to do. For example, you might use MODFLOW (USGS) to solve the advection-dispersion equation and MT3D for solute transport. Many hydrogeologists resort to hand-drawing plumes based on well chemistry data.
As mentioned in the comments, ArcGIS does provide some groundwater functionality through Spatial Analyst, but this isn't nearly as comprehensive as custom simulation software.
More info based on comments:
You could display this as a raster in ArcGIS, although I'm not sure if this would be a great end-product.
1) Merge your table so that you have all of the data in one sheet (x, y, other columns),
2) Add the table (as a CSV) to ArcMap,
3) right-click on the table and 'Display X, Y',
4) Export the output of this process to a shapefile.
You will now have a point shapefile. You can then interpolate this, using your level of contamination field, to a raster surface using a tool like 'IDW'.
You don't mention any Z coordinates, so I'm assuming here you only plan to display your plume in 2D space.