Controversial plans to create new holiday apartments at a water reservoir have been refused by councillors.