I think the parent comments are a separate issue from concerns about the NSA. Most people would agree that warrantless access to all data everywhere is a bad thing (smart water meter or not).

In this case, there are traditional limitations on law enforcement (requirement of a warrant) and a specific crime that has been committed.

In my opinion, using a warrant to get the data from the water usage device is no more problematic than using a warrant to search the house.