Hydroelectricity may not grab the headlines like other renewables, but it can deliver consistent returns over longer timescales.