Atlantic City water plant manager resigns