We have long known that connecting with nature in green spaces is great for our mental health. Now fresh research is showing that time near water – by the coast, rivers and even fountains in the park – is even more restorative