For long-term exposure over 100 years via the water release pathway, you would need radionuclides with a long half-life, high dose coefficient, and good solubility in water. Of the various radionuclides generated in a nuclear reactor, that practically only leaves Cs-137 as the relevant radionuclide. Cs-137 has a half-life of $30.1671\ \mathrm a$ and an effective dose coefficient (ingestion, adult members of the public) of $1.3\times10^{-8}\ \mathrm{Sv/Bq}$.
You are asking for a nuclear reactor near the Pacific. The largest single unit at the Pacific coast has a thermal power of $4590\ \mathrm{MW}$. The equilibrium Cs-137 activity in the reactor core is about $6.4\times10^{17}\ \mathrm{ Bq}$. (That’s about 2.5 times the inventory of the Chernobyl-4 core at the 1986 accident.) Let’s say you also have spent fuel corresponding to three unloaded cores in the spent fuel pool, which gives a maximum Cs-137 activity in the spent fuel pool of about $1.8\times10^{18}\ \mathrm{Bq}$. However, you would not be able to release this inventory to the environment.
Thus, you would have to look for other systems with a relevant radioactive inventory. The reactor coolant system has a Cs-137 activity concentration of about $3.2\times10^{8}\ \mathrm{Bq/Mg}$ during stable conditions and up to $6.4\times10^{9}\ \mathrm{Bq/Mg}$ during shutdown transients. Assuming a total coolant inventory of $321\ \mathrm{Mg}$, the total activity is up to $2.1\times10^{12}\ \mathrm{Bq}$. Some other potentially relevant Cs-137 inventories are:
- mixed-bed filters of the reactor coolant purification system: $1.9\times10^{13}\ \mathrm{Bq}$
- a spent resin storage tank of the spent resin flushing and storage system: $1.3\times10^{14}\ \mathrm{Bq}$
- degasifier of the reactor coolant degasifying system: $8.0\times10^{8}\ \mathrm{Bq}$
- volume control tank of the chemical and volume control system: $2.4\times10^{9}\ \mathrm{Bq}$
- a coolant storage tank of the coolant supply and storage system: $3.1\times10^{10}\ \mathrm{Bq}$
- boric acid evaporator of the coolant treatment system: $6.5\times10^{10}\ \mathrm{Bq}$
- condensate tank of the coolant treatment system: $8.9\times10^{7}\ \mathrm{Bq}$
- boric acid tank of the reactor boron and water make-up system: $3.4\times10^{11}\ \mathrm{Bq}$
- storage tank of the waste water storage and treatment system: $6.7\times10^{9}\ \mathrm{Bq}$
- evaporator of the waste water storage and treatment system: $1.3\times10^{11}\ \mathrm{Bq}$
- concentrate tank of the waste water storage and treatment system: $8.6\times10^{11}\ \mathrm{Bq}$
- monitoring tank of the waste water storage and treatment system: $6.7\times10^{6}\ \mathrm{Bq}$
These activities are design values; typical realistic values would be lower.
Assuming you have someone who knows how to operate the plant, it would be quite easy to release the inventory of a monitoring tank to the sea. However, this operation would take several hours considering that you have to release $70\ \mathrm{m^3}$ of waste water using only a small pump.
For any larger releases, you would have to make technical modifications to the plant.
In addition to the paramilitary terrorists needed to force an entry to the inner security area of the plant and maintain it for several hours, you would preferably have nine qualified plant operators (a shift supervisor, a reactor operator, a turbine operator, two mechanical infield operators, two electrical infield operators, and two I&C technicians). Maybe you would also need pipe welders. You might be able to make the necessary modifications to the waste water storage and treatment system in the limited available time so that you could release the inventory of a storage tank to the sea.
Therefore, your Cs-137 source term could be $6.7\times10^{9}\ \mathrm{Bq}$.
After $100\ \mathrm a$, the activity would still be about $6.7\times10^{8}\ \mathrm{Bq}$.
However, sea water isn’t used as drinking water in that region. And even if it would be used, it would have to be purified in a desalination plant before use anyway. That process would also effectively remove any relevant Cs-137 contamination. Therefore, you would have to find a different water body for your releases.
Note that a large fraction of the activity would actually end up in the sediment and thus would no longer be available for the contamination of drinking water. The partitioning of radionuclides between water and suspended matter can be described in terms of a distribution coefficients $K_\mathrm d$, expressed as the concentration ratio of the particulate phase to the dissolved phase under equilibrium conditions (in $\mathrm{Bq\ kg^{-1}}$ of suspended particulate matter per $\mathrm{Bq\ l^{-1}}$, i.e. in $\mathrm{l\ kg^{-1}}$). Values for Cs obtained from field measurements are between $1.6\times10^3\ \mathrm{l\ kg^{-1}}$ and $5.2\times10^5\ \mathrm{l\ kg^{-1}}$.
For the assessment of radiological consequences, we may assume that an adult member of public consumes $350\ \mathrm{l}$ of drinking water per year. The annual dose limit for members of the public is $1\ \mathrm{mSv}$. The effective dose coefficient (ingestion, adult members of the public) of Cs-137 is $1.3\times10^{-8}\ \mathrm{Sv/Bq}$. Thus, you could contaminate a water volume of
$$V=\frac{6.7\times10^{8}\ \mathrm{Bq}\times1.3\times10^{-8}\ \mathrm{Sv\ Bq^{-1}}\times350\ \mathrm{l}}{1\ \mathrm{mSv}}=3.0\times10^6\ \mathrm l=3.0\times10^3\ \mathrm{m^3}$$
Clearly, the psychological and social impact of such an incident would be larger than any actual radiological consequences.