The council is due to invest millions of pounds into water activities in its locality in order to attract tourism into the area