A competition can lead to direct wars/fights between members of populations, in which people (or animals) will die (if there is only limited food, only limited number of people can survive...). So a competition for water in a very dry area can directly lead to deaths.
Alternatively, those that loose the competition might die as a result of not getting the resource they were competing over.