Vale of Glamorgan Council argues having the water park will generate much needed income, but many residents are concerned about its potential impact