I don't know about the cancer, but too much arsenic is not good. When you have a well you should get the water tested, actually you can't get a permit to occupy a house if the water is not potable.
In our town there is a small vein in one area where there is too much arsenic and the people have to get a special filter system.
It is hard to imagine that a lot of arsenic could be healthy.