Water?

I''ve done a bit of research on water. And so I''ve heard, cube-mapping and bump mapping are the way to go? I want to achive water like in Call of Duty... It looks real, renders pretty fast, and theres no obvious loop like in some other games. But I really have no idea how to do bump mapping or cube mapping..... please point me in the right direction!