Okay so you have a few options.
1. EHT can put bubbles in.
For regular items, no bubbles but you can get wiggly water.
2. Use a blue brazier
3. Use a waterfall
Check out @munkfist 's Ebonheart for his fishtank to get an idea of what I mean about wiggly water.
Unfortunately, the Rupture is from the Coldharbour crown furnishing pack Braziers do work really well though!